using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using sgsBase;
 
namespace gaClear
{
[Serializable] public class DbNymxProdAccount :  DbObject
{
  public DbNymxProdAccount() : base()
  {
      Table = "dbo.nymx_prod_accounts";
      Database = "gagm_energy";
      Columns.AddColumn("prod_id", SqlDbType.VarChar, true, false);
      Columns.AddColumn("acct_id", SqlDbType.VarChar, true, false);
      Columns.AddColumn("exec_firm_id", SqlDbType.VarChar);
      Columns.AddColumn("exec_firm_name", SqlDbType.VarChar);
      Columns.AddColumn("clear_firm_id", SqlDbType.VarChar, true, false);
      Columns.AddColumn("clear_firm_name", SqlDbType.VarChar);
      Columns.AddColumn("broker_firm_id", SqlDbType.VarChar);
      Columns.AddColumn("broker_firm_name", SqlDbType.VarChar);
  }
  
  #region Properties
  
      public String ProdId
      {
          get { return Columns.StringAt(0);}
          set { Columns.SetValAt(0, value);}
      }

      public String AcctId
      {
          get { return Columns.StringAt(1);}
          set { Columns.SetValAt(1, value);}
      }

      public String ExecFirmId
      {
          get { return Columns.StringAt(2);}
          set { Columns.SetValAt(2, value);}
      }

      public String ExecFirmName
      {
          get { return Columns.StringAt(3);}
          set { Columns.SetValAt(3, value);}
      }

      public String ClearFirmId
      {
          get { return Columns.StringAt(4);}
          set { Columns.SetValAt(4, value);}
      }

      public String ClearFirmName
      {
          get { return Columns.StringAt(5);}
          set { Columns.SetValAt(5, value);}
      }

      public String BrokerFirmId
      {
          get { return Columns.StringAt(6);}
          set { Columns.SetValAt(6, value);}
      }

      public String BrokerFirmName
      {
          get { return Columns.StringAt(7);}
          set { Columns.SetValAt(7, value);}
      }

  
  #endregion
}
}
